BEGIN TRANSACTION
GO
ALTER TABLE dbo.data_PatientAdmitInfo ADD
	ChargesID smallint NULL,
	BalanceRec numeric(9, 2) NOT NULL CONSTRAINT DF_data_PatientAdmitInfo_BalanceRec DEFAULT 0
GO
ALTER TABLE dbo.data_PatientAdmitInfo SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

--------------------------------------------------------